home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The 640 MEG Shareware Studio 2
/
The 640 Meg Shareware Studio CD-ROM Volume II (Data Express)(1993).ISO
/
basic
/
imb9010.zip
/
SB3.BAS
Wrap
BASIC Source File
|
1990-10-03
|
2KB
|
68 lines
'PROGRAM - SRCHBLNK.BAS
'****************************************************************
'** Purpose - This program demonstrates how to search for blank *
'** fields *
'****************************************************************
CLS
'****************** Setup ISAM file **************************
TYPE SampleRecord
Field1 AS STRING * 20
Field2 AS STRING * 20
END TYPE
DIM SR AS SampleRecord 'Record variable to move data
' in and out of file
OPEN "TestFile.MDB" FOR ISAM SampleRecord "Table1" AS #1
CREATEINDEX #1, "FIELD1INDEX", 0, "Field1"
SETINDEX #1, "FIELD1INDEX" 'Set the active index
'******************* Add records to file **********************
RANDOMIZE TIMER
PRINT "Creating records": PRINT
FOR I = 1 TO 100
R$ = "REC" + STR$(I)
IF INT(20 * RND) = 10 THEN
SR.Field1 = ""
PRINT "Blank field record "; I
ELSE
SR.Field1 = R$ + " Field1 "
END IF
IF TEXTCOMP(SR.Field1, "") = 0 THEN SR.Field1 = "~"
SR.Field2 = R$ + " Field2 "
INSERT #1, SR
NEXT I
'****************** Scan for blank Field1 ********************
MOVEFIRST #1 'Set initial file postion
PRINT : PRINT "Searching for blank fields": PRINT
SEEKEQ #1, "~" '
DO
RETRIEVE #1, SR
IF TEXTCOMP(SR.Field1, "~") = 0 THEN
PRINT "Found it "; SR.Field1; SR.Field2
ELSE
EXIT DO
END IF
MOVENEXT #1
LOOP
PRINT
PRINT "End of file reached. Terminating program."
CLOSE 1
KILL "TESTFILE.MDB"
END